﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;

public partial class vp_Billing_ProductReport : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        GridView1.DataSource = GetTable();
        GridView1.DataBind();

    }

    private DataTable GetTable()
    {

        DataTable dtbl1 = new DataTable();


        dtbl1.Columns.Add("Product Code", typeof(string));
        dtbl1.Columns.Add("Category Code", typeof(string));
        dtbl1.Columns.Add("Counter Name", typeof(string));
        dtbl1.Columns.Add("Status", typeof(string));

        dtbl1.Rows.Add("Product01", "Category01", "T.Nagar", "Available");
        dtbl1.Rows.Add("Product01", "Category01", "T.Nagar", "Available");
        dtbl1.Rows.Add("Product01", "Category01", "T.Nagar", "Available");
        dtbl1.Rows.Add("Product02", "Category01", "Vadapalani", "Sold");

        return dtbl1;
    }
}